UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pvd2V1Tgzcmw7AUJFl18fLcepLrHAmqEoWjwueHUwkg='
WHERE
key_id = 'f818e6c02efacd559b5c4c188967c8aff6e83cb333e617740ad8bd1f36dcb046'
AND (
token = 'pvd2V1Tgzcmw7AUJFl18fLcepLrHAmqEoWjwueHUwkg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)