UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GjhyXS8Ric8G7oxkulzyFE/A5iSYcxDS4ZEDT5sOEe8='
WHERE
key_id = '0bf6a492208b0dae20c356c8dbaf24905532881300c3711b4084e5b9e06a52eb'
AND (
token = 'GjhyXS8Ric8G7oxkulzyFE/A5iSYcxDS4ZEDT5sOEe8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)