UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5XH+AwIQFAP5VeyCx7cfdY/Hhf7D0ff2Q5oj8BxjLYU='
WHERE
key_id = '97f396ff287e11850e9d2ad23724d6a528a0a312b9232910e7e95702c6240fe4'
AND (
token = '5XH+AwIQFAP5VeyCx7cfdY/Hhf7D0ff2Q5oj8BxjLYU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)