UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yxpuN+1JVKJh0nwsLTejm9dSW2n8NfLKFL+c39J7YEw='
WHERE
key_id = 'c172210d3decb99c50743cc2cad5615492a5c7261cc2436c6b543870822b615b'
AND (
token = 'yxpuN+1JVKJh0nwsLTejm9dSW2n8NfLKFL+c39J7YEw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)