UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yN9IVEGbfZlzA120EE7ZicBVGJC8aBOQxv8jFQgMQ4g='
WHERE
key_id = '2c04c85dd803d7e52fda6b4e1e74e1647e923e4c7e43cb409c83587bb506e44a'
AND (
token = 'yN9IVEGbfZlzA120EE7ZicBVGJC8aBOQxv8jFQgMQ4g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)