UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '1LjMq3+4RiCmtaKfb+WJNE28agJ3DRT09BuQVQkVX+k=' 
WHERE 
  key_id = 'fe93448568f423741f9888d9a24e3e087f0c91a6a1c1ff464b5595e4b3964bb1' 
  AND (
    token = '1LjMq3+4RiCmtaKfb+WJNE28agJ3DRT09BuQVQkVX+k=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00038