UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'oEoHBylUGjTVL9pQ2HHCiFsJejbwoPaKSArKoD68CbU=' 
WHERE 
  key_id = '6a150cb451854e829772f116e62d6bde3f2ed484c104c59510b10dc4af9bca74' 
  AND (
    token = 'oEoHBylUGjTVL9pQ2HHCiFsJejbwoPaKSArKoD68CbU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026