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