UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zbozHP8ZZmjwaNSz9mRj3sthPFsbCJIhB4cq0ompgb8='
WHERE
key_id = '5b28149d68ee81911a886edbeb01e6267bacc8c57cddd9d46200b75bc481ccf9'
AND (
token = 'zbozHP8ZZmjwaNSz9mRj3sthPFsbCJIhB4cq0ompgb8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)