UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8GUI6pXDfvjhaQkrOT3wfNbWaHHgPLE1s0A37WhTA/A='
WHERE
key_id = '38273dd66472c9b7d110342e6589cb181f74c5f76c3e9915b62e399fe3ff39dd'
AND (
token = '8GUI6pXDfvjhaQkrOT3wfNbWaHHgPLE1s0A37WhTA/A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)