UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'p5w2RcWU1zdWO3Fhj6CKw+OqVbQiH5rMgkr93y8yhtM=' 
WHERE 
  key_id = '0a59c7064197abbf684ef467418f7635b1955d231a0b91a95e8b6fdc82098a48' 
  AND (
    token = 'p5w2RcWU1zdWO3Fhj6CKw+OqVbQiH5rMgkr93y8yhtM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030