UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xVAuH33J1O5mLK5BnUGU0YH7/6cDbIMcCjpE8+JJd9o='
WHERE
key_id = 'e9f7a2ece29d9e3a6e48744f11be423808cb1e3cacd1ef18c2eb4547c4adb0f0'
AND (
token = 'xVAuH33J1O5mLK5BnUGU0YH7/6cDbIMcCjpE8+JJd9o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)