UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Re7U+uDPXVugPz+3grYapYCX03+o8dbaDu0kOa9bi5Q='
WHERE
key_id = 'f1800fbe6b04c6828308da251378e9194331884882dfd715618e33c1c3dfd0f0'
AND (
token = 'Re7U+uDPXVugPz+3grYapYCX03+o8dbaDu0kOa9bi5Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)