UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VJjz1NYXXB48LLzIF59jNPIA+f9vOg+EaTj1TUlhgd8='
WHERE
key_id = 'c92ba49a1b792f1bf429408aae4930d930cb2f23356e898b4e32ff4ba0895c3e'
AND (
token = 'VJjz1NYXXB48LLzIF59jNPIA+f9vOg+EaTj1TUlhgd8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)