UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xEIy3yzs817x2yV7wW4NqgnaCdNpWps0nmoh37ZSjoU='
WHERE
key_id = '6006b15709ee54fd1cab38cabfca88b114c619ffaaf28bfd696547a4b5d0ffcb'
AND (
token = 'xEIy3yzs817x2yV7wW4NqgnaCdNpWps0nmoh37ZSjoU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)