UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pZv7QdSS2939wfJM8CcmAt+y5lLWlwyDonL+XEo0jFw='
WHERE
key_id = '69189ae4af03ffe256ac0846ff0ae9b2bb41a8a54333b5071793fe333a3e0c95'
AND (
token = 'pZv7QdSS2939wfJM8CcmAt+y5lLWlwyDonL+XEo0jFw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)