UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'lyovlGc45mb2wUWdrlA619BP3Tv8otX6aLsPOKCpc54=' 
WHERE 
  key_id = '8da51d665367b103d9a1e89872eaaeba1e602e1fdc9078f15e50987d50250397' 
  AND (
    token = 'lyovlGc45mb2wUWdrlA619BP3Tv8otX6aLsPOKCpc54=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032