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