UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '8dMIoE3NMVG6r47Tw4SzUh6n6rwb32GFMI8GLsO1HtA=' 
WHERE 
  key_id = '58dd9cdf8a43bbb2709a3f8aa92b93ca2662339be8ff383a55443f7f6c31bedc' 
  AND (
    token = '8dMIoE3NMVG6r47Tw4SzUh6n6rwb32GFMI8GLsO1HtA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043