UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hI0km8LbYnRW676uFyNQUUJ4Y9ndPqLGQq73x+DfdG4='
WHERE
key_id = 'e6a5ac2a4085b2bfbaf332bb618325c45aba180e138b08ffb4d85d7018f9d04d'
AND (
token = 'hI0km8LbYnRW676uFyNQUUJ4Y9ndPqLGQq73x+DfdG4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)