UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+bmIn/Yf9ZbPrkuyNp9vvEa1yjVhH1eBMiUIgAPRW1g=' 
WHERE 
  key_id = '696c1e6e5b7689a68d2aeb163a80f67e2ad2f0235b26fb45991a626e26534d4f' 
  AND (
    token = '+bmIn/Yf9ZbPrkuyNp9vvEa1yjVhH1eBMiUIgAPRW1g=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029