UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '7pAxE8YkbuEH7N9MATTU5FI08d6TvctWZndwfMUlVUA=' 
WHERE 
  key_id = 'ffe81dbb7ae0dfccea4294decb36e52f1dd895060d5554f5c5540b7af338d1f6' 
  AND (
    token = '7pAxE8YkbuEH7N9MATTU5FI08d6TvctWZndwfMUlVUA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022