UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1KaNfMq0PFGJzySzZ4buLPJzUl9Bqj6HuLUUKCZgsoE='
WHERE
key_id = 'd42f9ff973288ace50a07e1b8766546765f03f601c6f5d2fc6f7a4d337c388c2'
AND (
token = '1KaNfMq0PFGJzySzZ4buLPJzUl9Bqj6HuLUUKCZgsoE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)