UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'am2uvdQoRO7ezh8WoXwjKe//IRFYxNjznh/2LPYWCpo=' 
WHERE 
  key_id = '4ee0c95fce8fc03ee76e26d06ad72f5b85f1cf180682f80d0c869ed6f2d83482' 
  AND (
    token = 'am2uvdQoRO7ezh8WoXwjKe//IRFYxNjznh/2LPYWCpo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036