UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'it7MLOUZdEWyDRlfvF/w/lU87FMok/4M/nlO6FY/AtY='
WHERE
key_id = 'e47981154ff8a9739a1d11c9e6bf41f798a78fb36d7a49c2a1e1df5df391bb52'
AND (
token = 'it7MLOUZdEWyDRlfvF/w/lU87FMok/4M/nlO6FY/AtY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)