UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'vV3f5NQrvweVHhsLPtM4BhzwviX0NmPV9I/uW9U4vmE=' 
WHERE 
  key_id = '6473b0e903801e4e28a46c44adc8d1f77f9cee3c7c22559830da59e2db4b303e' 
  AND (
    token = 'vV3f5NQrvweVHhsLPtM4BhzwviX0NmPV9I/uW9U4vmE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028