UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'GS6/621Fvw91zk/bhP4bvc8H7Da7EdOxQy6G3DO/aUY=' 
WHERE 
  key_id = 'b970aaea84f7cacb763a26cb850a330b3a9b519231684605a4f6e9478d8f1533' 
  AND (
    token = 'GS6/621Fvw91zk/bhP4bvc8H7Da7EdOxQy6G3DO/aUY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028