UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'PBs+nldsMO9S7tglPfQsp2rw5/W+vYRLPvkbTzEzS+g=' 
WHERE 
  key_id = 'f6e64e04151d5eab0a419c40a91130b1d587663a025cecade674b152a4aa2778' 
  AND (
    token = 'PBs+nldsMO9S7tglPfQsp2rw5/W+vYRLPvkbTzEzS+g=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027