UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'N2WK8do3YRQj+4mFxCFCxdmJs9Cje68bxyE5cNfATUQ=' 
WHERE 
  key_id = '57596e30493cb2749a538dff1523cbd6a7a67b1d6dbcfab5df444aca6114d1c1' 
  AND (
    token = 'N2WK8do3YRQj+4mFxCFCxdmJs9Cje68bxyE5cNfATUQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047