UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1xA+DpEoArVTqEJbTXvYp9cZiWMV4umb2iLCnz3504E='
WHERE
key_id = '7a0648572847164a236343fcfc9255ca60ff17d378e7bd33fca5a19f57bc8131'
AND (
token = '1xA+DpEoArVTqEJbTXvYp9cZiWMV4umb2iLCnz3504E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)