UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CQ9gLEVHok6VaDA0o7QKQtdwEyvElbf5VPWxE8szGMg='
WHERE
key_id = 'a5b635b3ca10300cc2d0a09db4f7155f50e66245785d6684f1412f4f96ca6a20'
AND (
token = 'CQ9gLEVHok6VaDA0o7QKQtdwEyvElbf5VPWxE8szGMg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)