UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XRdIcpiEFAY1hXxfmrdB1/FFViRdqBSXKxyuXy/vYxU='
WHERE
key_id = '0396ff2c31468604d06a9ae70483ef47d2446cf8dedf1edc46d602de85cd9dc7'
AND (
token = 'XRdIcpiEFAY1hXxfmrdB1/FFViRdqBSXKxyuXy/vYxU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)