UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RSqxIK+VXXxexR6SpYMnN3PLmTEdASILFAlxIn5AHcw='
WHERE
key_id = 'bc35354e849296272ce9eebbafccf4d0b1ad4ca234d929831e8c90a839d4f2d7'
AND (
token = 'RSqxIK+VXXxexR6SpYMnN3PLmTEdASILFAlxIn5AHcw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)