UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9DK40XnO6JpurirmgSHmdEitMmICtpjkqYXaA3jdCE8='
WHERE
key_id = '3689420e729138f124a6ed9183df9d8dd23e2d9be9ac4e8998ee7820a49ff4a9'
AND (
token = '9DK40XnO6JpurirmgSHmdEitMmICtpjkqYXaA3jdCE8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)