UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zDkxvZuRlYuTnlFkToH8aCt182s38W+uZ/f0EGW8mKU='
WHERE
key_id = '12b00c8687e014ca6f37978ace1c34755f0f1d8e0ebe735a97af293820075fb5'
AND (
token = 'zDkxvZuRlYuTnlFkToH8aCt182s38W+uZ/f0EGW8mKU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)