UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8Db4AjfGxm9RUuY45O1MOe7SriXrvmLfWrU/8SYEJMM='
WHERE
key_id = '406b337e6bf7d755cebd5d8d7f1ec87bb5c80d509cd6b70a57f0a3b361eee6ee'
AND (
token = '8Db4AjfGxm9RUuY45O1MOe7SriXrvmLfWrU/8SYEJMM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)