UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aQwa3wpsm2mV0IWnAk7J/mRQXpkVZCkA0vw9f8WoyKA='
WHERE
key_id = '4dd582b66dd43815d245f68f65be9d0a4ee2e88c6bea3a6cec5b13ad1ad500de'
AND (
token = 'aQwa3wpsm2mV0IWnAk7J/mRQXpkVZCkA0vw9f8WoyKA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)