UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hsnFQxy8LSKx0GN5/ki/d/85vikUAY1aKrOMOCAjEKY='
WHERE
key_id = '1e7cd5bc29ba1c35d27a841cc0c1501ecb7438296e136a411571858e57e71ec4'
AND (
token = 'hsnFQxy8LSKx0GN5/ki/d/85vikUAY1aKrOMOCAjEKY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)