UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VGBo8z3NxmRhTeDzB1R6fsasVLX79xLki0v0WJX1gZQ='
WHERE
key_id = 'ef98fae5c46410d5780728f7f90693ed960b3b7aa3635ebda7a3f502ebb8ebdc'
AND (
token = 'VGBo8z3NxmRhTeDzB1R6fsasVLX79xLki0v0WJX1gZQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)