UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8sd5MmTAkL/EygHwfsMJv7gH/jhxxwq0ZVa0K9YaJqU='
WHERE
key_id = '79dcc0d54e14935b3e1aa40a42c1b842f8ec250e7ade38ff13de0bcc07808fbe'
AND (
token = '8sd5MmTAkL/EygHwfsMJv7gH/jhxxwq0ZVa0K9YaJqU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)