UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zDNI1yajDHNOUwMSIH2+kkhXvHo8YYdoPNXKz42QKvo='
WHERE
key_id = 'af72df0d6b30e1d2c8ee11def96349e657c003bba9ff7572c81da91b2b9b8d06'
AND (
token = 'zDNI1yajDHNOUwMSIH2+kkhXvHo8YYdoPNXKz42QKvo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)