UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'goZbRsL0NBNk+P/lLi3GRyteR/wG0TZ+09pY+N9+gPM=' 
WHERE 
  key_id = '6d2d3acfda884ef846b482eb42b06c4b1bb7e860ee6bd741f10d77bd86f7ea25' 
  AND (
    token = 'goZbRsL0NBNk+P/lLi3GRyteR/wG0TZ+09pY+N9+gPM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044