UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iRf59E85heA6x6VTfnnWNSLnfplVRFM5mHHZI+NXCZs='
WHERE
key_id = 'f6a894dfe321fe570d24a9a13c4b8d88aa61075fdd158a1c83b1d7e9c8f8b63a'
AND (
token = 'iRf59E85heA6x6VTfnnWNSLnfplVRFM5mHHZI+NXCZs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)