UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hDzoR5x5+9FqB+9I0FbbSiw0FABrxdVgWd4xHguuuis='
WHERE
key_id = '00e6d7f2c025119b974b4376ea70a19cdd5f7455a40db0cade437ec90ab2cc72'
AND (
token = 'hDzoR5x5+9FqB+9I0FbbSiw0FABrxdVgWd4xHguuuis='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)