UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'vxzpyHB+HboK10NHFEkF1bIGPyvm2S2u4+i+KcS2aqw=' 
WHERE 
  key_id = '19229687c837abb2a0ae69a5ea6f4300424fb0d5b8f626513867a308639f1c71' 
  AND (
    token = 'vxzpyHB+HboK10NHFEkF1bIGPyvm2S2u4+i+KcS2aqw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035